2024-03-19 18:13:12,507 [ 249649 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/_temp/test/git-repo-copy (runner:41, check_args_and_update_paths) 2024-03-19 18:13:12,507 [ 249649 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/_temp/test/git-repo-copy/tests/integration (runner:89, check_args_and_update_paths) 2024-03-19 18:13:12,507 [ 249649 ] INFO : src dir is not set. Will use /home/ubuntu/_work/_temp/test/git-repo-copy/src (runner:96, check_args_and_update_paths) 2024-03-19 18:13:12,507 [ 249649 ] INFO : base_configs_dir: /home/ubuntu/_work/_temp/test/git-repo-copy/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/_temp/test/git-repo-copy/tests/integration (runner:98, check_args_and_update_paths) clickhouse_integration_tests_volume WARNING: Ignoring custom format, because both --format and --quiet are set. Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_cigfru --privileged --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/_temp/test/git-repo-copy/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/_temp/test/git-repo-copy/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/_temp/test/git-repo-copy/src/Server/grpc_protos:/ClickHouse/src/Server/grpc_protos --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e XTABLES_LOCKFILE=/run/host/xtables.lock -e PYTHONUNBUFFERED=1 -e DOCKER_DOTNET_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_HELPER_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_BASE_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_KERBERIZED_HADOOP_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_KERBEROS_KDC_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_MYSQL_JAVA_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_MYSQL_JS_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_MYSQL_PHP_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=0-0a8ac3b092733da37e3e2a0079c486938a36790d -e PYTEST_OPTS='--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_storage_mysql/test.py::test_binary_type test_storage_mysql/test.py::test_enum_type test_storage_mysql/test.py::test_external_settings test_storage_mysql/test.py::test_insert_on_duplicate_select test_storage_mysql/test.py::test_insert_select test_storage_mysql/test.py::test_many_connections test_storage_mysql/test.py::test_mysql_distributed test_storage_mysql/test.py::test_mysql_in test_storage_mysql/test.py::test_mysql_null test_storage_mysql/test.py::test_predefined_connection_configuration test_storage_mysql/test.py::test_replace_select test_storage_mysql/test.py::test_settings test_storage_mysql/test.py::test_settings_connection_wait_timeout test_storage_mysql/test.py::test_table_function test_storage_mysql/test.py::test_where test_storage_policies/test.py::test_storage_policy_configuration_change test_table_function_mongodb/test.py::test_auth_source[False] test_table_function_mongodb/test.py::test_complex_data_type[False] test_table_function_mongodb/test.py::test_incorrect_data_type[False] test_table_function_mongodb/test.py::test_missing_columns[False] test_table_function_mongodb/test.py::test_no_credentials[False] test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data -vvv' altinityinfra/integration-tests-runner:0-0a8ac3b092733da37e3e2a0079c486938a36790d '. Start tests ============================= test session starts ============================== platform linux -- Python 3.8.10, pytest-8.0.2, pluggy-1.4.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: repeat-0.9.3, xdist-3.5.0, random-0.2, timeout-2.2.0, order-1.0.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [25 items] scheduling tests via LoadFileScheduling test_storage_policies/test.py::test_storage_policy_configuration_change test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data test_storage_mysql/test.py::test_binary_type test_table_function_mongodb/test.py::test_auth_source[False] [gw1] [ 4%] PASSED test_table_function_mongodb/test.py::test_auth_source[False] test_table_function_mongodb/test.py::test_complex_data_type[False] [gw3] [ 8%] PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data [gw1] [ 12%] PASSED test_table_function_mongodb/test.py::test_complex_data_type[False] test_table_function_mongodb/test.py::test_incorrect_data_type[False] [gw1] [ 16%] PASSED test_table_function_mongodb/test.py::test_incorrect_data_type[False] test_table_function_mongodb/test.py::test_missing_columns[False] [gw1] [ 20%] PASSED test_table_function_mongodb/test.py::test_missing_columns[False] test_table_function_mongodb/test.py::test_no_credentials[False] [gw1] [ 24%] PASSED test_table_function_mongodb/test.py::test_no_credentials[False] test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] [gw1] [ 28%] PASSED test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] test_table_function_mongodb/test.py::test_secure_connection[True] [gw4] [ 32%] PASSED test_storage_policies/test.py::test_storage_policy_configuration_change [gw0] [ 36%] PASSED test_storage_mysql/test.py::test_binary_type test_storage_mysql/test.py::test_enum_type [gw0] [ 40%] PASSED test_storage_mysql/test.py::test_enum_type test_storage_mysql/test.py::test_external_settings [gw0] [ 44%] PASSED test_storage_mysql/test.py::test_external_settings test_storage_mysql/test.py::test_insert_on_duplicate_select [gw1] [ 48%] PASSED test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] [gw0] [ 52%] PASSED test_storage_mysql/test.py::test_insert_on_duplicate_select test_storage_mysql/test.py::test_insert_select [gw0] [ 56%] PASSED test_storage_mysql/test.py::test_insert_select test_storage_mysql/test.py::test_many_connections [gw0] [ 60%] PASSED test_storage_mysql/test.py::test_many_connections test_storage_mysql/test.py::test_mysql_distributed [gw0] [ 64%] PASSED test_storage_mysql/test.py::test_mysql_distributed test_storage_mysql/test.py::test_mysql_in [gw0] [ 68%] PASSED test_storage_mysql/test.py::test_mysql_in test_storage_mysql/test.py::test_mysql_null [gw0] [ 72%] PASSED test_storage_mysql/test.py::test_mysql_null test_storage_mysql/test.py::test_predefined_connection_configuration [gw0] [ 76%] PASSED test_storage_mysql/test.py::test_predefined_connection_configuration test_storage_mysql/test.py::test_replace_select [gw0] [ 80%] PASSED test_storage_mysql/test.py::test_replace_select test_storage_mysql/test.py::test_settings [gw0] [ 84%] PASSED test_storage_mysql/test.py::test_settings test_storage_mysql/test.py::test_settings_connection_wait_timeout [gw0] [ 88%] PASSED test_storage_mysql/test.py::test_settings_connection_wait_timeout test_storage_mysql/test.py::test_table_function [gw0] [ 92%] PASSED test_storage_mysql/test.py::test_table_function test_storage_mysql/test.py::test_where [gw0] [ 96%] PASSED test_storage_mysql/test.py::test_where [gw1] [100%] PASSED test_table_function_mongodb/test.py::test_simple_select[False] =============================== warnings summary =============================== test_table_function_mongodb/test.py::test_auth_source[False] test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] /ClickHouse/tests/integration/helpers/cluster.py:2333: DeprecationWarning: database_names is deprecated. Use list_database_names instead. logging.debug(f"Connected to Mongo dbs: {connection.database_names()}") test_table_function_mongodb/test.py::test_auth_source[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:226: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead admin_db.add_user( test_table_function_mongodb/test.py::test_complex_data_type[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:88: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_complex_data_type[False] test_table_function_mongodb/test.py::test_secure_connection[True] test_table_function_mongodb/test.py::test_simple_select[False] /usr/local/lib/python3.8/dist-packages/pymongo/database.py:1247: DeprecationWarning: Creating a user with the read_only option or without roles is deprecated in MongoDB >= 2.6 warnings.warn("Creating a user with the read_only option " test_table_function_mongodb/test.py::test_incorrect_data_type[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:123: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_missing_columns[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:262: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:185: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_secure_connection[True] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:144: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") test_table_function_mongodb/test.py::test_simple_select[False] /ClickHouse/tests/integration/test_table_function_mongodb/test.py:46: DeprecationWarning: add_user is deprecated and will be removed in PyMongo 4.0. Use db.command with createUser or updateUser instead db.add_user("root", "clickhouse") -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ============================== slowest durations =============================== 48.12s setup test_storage_mysql/test.py::test_binary_type 41.67s call test_table_function_mongodb/test.py::test_simple_select[False] 25.94s setup test_table_function_mongodb/test.py::test_secure_connection[True] 24.71s setup test_table_function_mongodb/test.py::test_simple_select[False] 21.97s setup test_table_function_mongodb/test.py::test_auth_source[False] 17.04s setup test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 16.88s setup test_storage_policies/test.py::test_storage_policy_configuration_change 13.63s call test_storage_policies/test.py::test_storage_policy_configuration_change 11.09s call test_storage_mysql/test.py::test_settings_connection_wait_timeout 7.55s teardown test_storage_mysql/test.py::test_where 7.03s call test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 6.85s call test_storage_mysql/test.py::test_mysql_distributed 5.59s call test_storage_mysql/test.py::test_predefined_connection_configuration 3.82s teardown test_table_function_mongodb/test.py::test_simple_select[False] 3.20s teardown test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data 2.64s call test_storage_mysql/test.py::test_where 2.50s call test_storage_mysql/test.py::test_external_settings 2.26s call test_storage_mysql/test.py::test_table_function 2.19s call test_storage_mysql/test.py::test_settings 1.95s call test_storage_mysql/test.py::test_replace_select 1.89s call test_storage_mysql/test.py::test_insert_on_duplicate_select 1.88s call test_storage_mysql/test.py::test_mysql_in 1.70s teardown test_storage_policies/test.py::test_storage_policy_configuration_change 1.63s call test_table_function_mongodb/test.py::test_secure_connection[True] 1.62s call test_storage_mysql/test.py::test_insert_select 1.37s call test_storage_mysql/test.py::test_mysql_null 1.35s call test_storage_mysql/test.py::test_many_connections 1.27s call test_table_function_mongodb/test.py::test_complex_data_type[False] 1.15s call test_storage_mysql/test.py::test_enum_type 1.07s call test_table_function_mongodb/test.py::test_auth_source[False] 0.70s call test_storage_mysql/test.py::test_binary_type 0.63s call test_table_function_mongodb/test.py::test_incorrect_data_type[False] 0.54s call test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 0.49s call test_table_function_mongodb/test.py::test_missing_columns[False] 0.34s call test_table_function_mongodb/test.py::test_no_credentials[False] 0.00s teardown test_storage_mysql/test.py::test_binary_type 0.00s teardown test_table_function_mongodb/test.py::test_auth_source[False] 0.00s setup test_table_function_mongodb/test.py::test_missing_columns[False] 0.00s teardown test_storage_mysql/test.py::test_settings_connection_wait_timeout 0.00s setup test_storage_mysql/test.py::test_table_function 0.00s setup test_table_function_mongodb/test.py::test_complex_data_type[False] 0.00s teardown test_storage_mysql/test.py::test_table_function 0.00s setup test_storage_mysql/test.py::test_where 0.00s teardown test_table_function_mongodb/test.py::test_incorrect_data_type[False] 0.00s teardown test_table_function_mongodb/test.py::test_secure_connection[True] 0.00s setup test_storage_mysql/test.py::test_enum_type 0.00s setup test_table_function_mongodb/test.py::test_no_credentials[False] 0.00s setup test_storage_mysql/test.py::test_mysql_in 0.00s setup test_storage_mysql/test.py::test_mysql_null 0.00s setup test_storage_mysql/test.py::test_settings 0.00s setup test_storage_mysql/test.py::test_many_connections 0.00s teardown test_storage_mysql/test.py::test_replace_select 0.00s setup test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 0.00s setup test_storage_mysql/test.py::test_insert_on_duplicate_select 0.00s teardown test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] 0.00s setup test_storage_mysql/test.py::test_mysql_distributed 0.00s teardown test_table_function_mongodb/test.py::test_complex_data_type[False] 0.00s teardown test_storage_mysql/test.py::test_insert_on_duplicate_select 0.00s teardown test_storage_mysql/test.py::test_mysql_in 0.00s setup test_storage_mysql/test.py::test_settings_connection_wait_timeout 0.00s setup test_table_function_mongodb/test.py::test_incorrect_data_type[False] 0.00s setup test_storage_mysql/test.py::test_external_settings 0.00s setup test_storage_mysql/test.py::test_predefined_connection_configuration 0.00s teardown test_storage_mysql/test.py::test_insert_select 0.00s setup test_storage_mysql/test.py::test_replace_select 0.00s teardown test_storage_mysql/test.py::test_settings 0.00s teardown test_storage_mysql/test.py::test_mysql_distributed 0.00s setup test_storage_mysql/test.py::test_insert_select 0.00s teardown test_storage_mysql/test.py::test_many_connections 0.00s teardown test_storage_mysql/test.py::test_external_settings 0.00s teardown test_storage_mysql/test.py::test_enum_type 0.00s teardown test_table_function_mongodb/test.py::test_missing_columns[False] 0.00s teardown test_storage_mysql/test.py::test_predefined_connection_configuration 0.00s teardown test_storage_mysql/test.py::test_mysql_null 0.00s teardown test_table_function_mongodb/test.py::test_no_credentials[False] =========================== short test summary info ============================ PASSED test_table_function_mongodb/test.py::test_auth_source[False] PASSED test_temporary_data_in_cache/test.py::test_cache_evicted_by_temporary_data PASSED test_table_function_mongodb/test.py::test_complex_data_type[False] PASSED test_table_function_mongodb/test.py::test_incorrect_data_type[False] PASSED test_table_function_mongodb/test.py::test_missing_columns[False] PASSED test_table_function_mongodb/test.py::test_no_credentials[False] PASSED test_table_function_mongodb/test.py::test_predefined_connection_configuration[False] PASSED test_storage_policies/test.py::test_storage_policy_configuration_change PASSED test_storage_mysql/test.py::test_binary_type PASSED test_storage_mysql/test.py::test_enum_type PASSED test_storage_mysql/test.py::test_external_settings PASSED test_table_function_mongodb/test.py::test_secure_connection[True] PASSED test_storage_mysql/test.py::test_insert_on_duplicate_select PASSED test_storage_mysql/test.py::test_insert_select PASSED test_storage_mysql/test.py::test_many_connections PASSED test_storage_mysql/test.py::test_mysql_distributed PASSED test_storage_mysql/test.py::test_mysql_in PASSED test_storage_mysql/test.py::test_mysql_null PASSED test_storage_mysql/test.py::test_predefined_connection_configuration PASSED test_storage_mysql/test.py::test_replace_select PASSED test_storage_mysql/test.py::test_settings PASSED test_storage_mysql/test.py::test_settings_connection_wait_timeout PASSED test_storage_mysql/test.py::test_table_function PASSED test_storage_mysql/test.py::test_where PASSED test_table_function_mongodb/test.py::test_simple_select[False] ================= 25 passed, 13 warnings in 125.70s (0:02:05) ==================